Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$FIXED_TABLE

This view displays all dynamic performance tables, views, and derived tables in the database. Some `V$` tables (for example, `V$ROLLNAME`) refer to real tables and are therefore not listed.

Column | Datatype | Description
--- | --- | ---
`NAME` | `VARCHAR2(30)` | Name of the object
`OBJECT_ID` | `NUMBER` | Identifier of the fixed object
`TYPE` | `VARCHAR2(5)` | Object type (`TABLE` | `VIEW`)
`TABLE_NUM` | `NUMBER` | Number that identifies the dynamic performance table if it is of type `TABLE`